/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package DAO;

/**
 *
 * @author 20cent
 */
public class ChampsBDD {
    /*
     * Table utilisateur
     */
    public static final String TABLE_UTILISATEUR = "utilisateur";
    
    public static final String UTILISATEUR_ID = "utilisateur_id";
    public static final String TECHNICIEN_ID = "technicien_id";
    public static final String UTILISATEUR_NOM = "utilisateur_nom";
    public static final String UTILISATEUR_PRENOM = "utilisateur_prenom";
    public static final String UTILISATEUR_TYPE = "utilisateur_type";
    public static final String UTILISATEUR_EQUIPEMENT = "technicien_equipement";
    
    /*
     * Table station
     */
    public static final String TABLE_STATION = "station";
    
    public static final String STATION_ID = "station_id";
    public static final String STATION_COORD = "station_coordonees";
    public static final String STATION_CAPACITE = "station_capacite";
    
    /*
     * Table velo
     */
    public static final String TABLE_VELO = "velo";
    
    public static final String VELO_ID = "velo_id";
    public static final String VELO_SERIAL = "velo_serial";
    public static final String VELO_DATE_ENTREE = "velo_date_entree";
    
    /*
     * Table type incident
     */
    public static final String TABLE_TYPE_INCIDENT = "typeincident";
    
    public static final String TYPE_INC_ID = "typeinc_id";
    public static final String TYPE_INC_NOM = "typeinc_nom";
    public static final String TYPE_INC_DESCRIPTION = "typeinc_description";
    public static final String TYPE_INC_PROCEDURE = "typeinc_procedure";
    public static final String TYPE_INC_OUTILS = "typeinc_outils";
    
    /*
     * Table incident
     */
    public static final String TABLE_INCIDENT = "incident";
    
    public static final String INCIDENT_ID = "incident_id";
    public static final String INCIDENT_DATE_OUVERTURE = "incident_date_ouverture";
    public static final String INCIDENT_DATE_FERMETURE = "incident_date_fermeture";
    public static final String INCIDENT_STATUT = "incident_statut";
    public static final String INCIDENT_PRIORITE = "incident_priorite";
    public static final String INCIDENT_COMMENTAIRE = "incident_commentaire";
}

